package com.zhxy.manager.dao;

import com.zhxy.manager.dto.AssociationTjDto;
import com.zhxy.manager.entity.Association;
import com.zhxy.manager.entity.Course;
import com.zhxy.manager.entity.Dormitory;
import com.zhxy.manager.excel.AssociationExcel;

import java.util.List;

/**
 *  兴趣社团
 * @author ZM
 */
public interface AssociationDao {
    //新增
    int add(Association association);

    //查询
    List<Association> selectAll();

    //根据id删除
    int del(int id);

    //修改
    int update(Association association);

    //查询,带条件 动态sql
    List<Association> selectWhere(String name);

    //批量删除
    int delBatch(int[] ids);

    //批量新增
    int addBatch(List<AssociationExcel> association);

    //实现图表统计
    List<AssociationTjDto> selectTj();
}
